シストレクルーク

トップ > シストレコラム

シストレコラム

シストレコラム一覧

≪ 前 次 ≫ 全2件 1 - 2

PAGE TOP
  • 会社概要
  • お問い合わせ
(develop) 7 queries took 1 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT `Columnist`.`id`, `Columnist`.`name`, `Columnist`.`title`, `Columnist`.`body`, `Columnist`.`image`, `Columnist`.`active`, `Columnist`.`created`, `Columnist`.`modified`, `Columnist`.`deleted`, `Columnist`.`deleted_date` FROM `columnists` AS `Columnist` WHERE 1 = 1 330
2SELECT COUNT(*) AS `count` FROM `columns` AS `Column` LEFT JOIN `columnists` AS `Columnists` ON (`Column`.`columnists` = `Columnists`.`id`) WHERE `Column`.`active` = 1 AND `Column`.`columnists` = 1 110
3SELECT `Column`.`id`, `Column`.`columnists`, `Column`.`datetime`, `Column`.`title`, `Column`.`body1`, `Column`.`body2`, `Column`.`body3`, `Column`.`image1`, `Column`.`image2`, `Column`.`image3`, `Column`.`active`, `Column`.`created`, `Column`.`modified`, `Column`.`deleted`, `Column`.`deleted_date`, `Columnists`.`id`, `Columnists`.`name`, `Columnists`.`title`, `Columnists`.`body`, `Columnists`.`image`, `Columnists`.`active`, `Columnists`.`created`, `Columnists`.`modified`, `Columnists`.`deleted`, `Columnists`.`deleted_date` FROM `columns` AS `Column` LEFT JOIN `columnists` AS `Columnists` ON (`Column`.`columnists` = `Columnists`.`id`) WHERE `Column`.`active` = 1 AND `Column`.`columnists` = 1 ORDER BY `Column`.`created` DESC, `Column`.`id` desc LIMIT 10221
4SELECT `Column`.`id`, `Column`.`columnists`, `Column`.`datetime`, `Column`.`title`, `Column`.`body1`, `Column`.`body2`, `Column`.`body3`, `Column`.`image1`, `Column`.`image2`, `Column`.`image3`, `Column`.`active`, `Column`.`created`, `Column`.`modified`, `Column`.`deleted`, `Column`.`deleted_date`, `Columnists`.`id`, `Columnists`.`name`, `Columnists`.`title`, `Columnists`.`body`, `Columnists`.`image`, `Columnists`.`active`, `Columnists`.`created`, `Columnists`.`modified`, `Columnists`.`deleted`, `Columnists`.`deleted_date` FROM `columns` AS `Column` LEFT JOIN `columnists` AS `Columnists` ON (`Column`.`columnists` = `Columnists`.`id`) WHERE `Column`.`active` = 1 AND `Column`.`deleted` = 0 ORDER BY `Column`.`datetime` desc, `Column`.`id` asc LIMIT 3330
5SELECT `Ranking`.`id`, `Ranking`.`company`, `Ranking`.`product`, `Ranking`.`url`, `Ranking`.`type`, `Ranking`.`body`, `Ranking`.`star`, `Ranking`.`image`, `Ranking`.`sort_id`, `Ranking`.`active`, `Ranking`.`created`, `Ranking`.`modified`, `Ranking`.`deleted`, `Ranking`.`deleted_date` FROM `rankings` AS `Ranking` WHERE `Ranking`.`active` = 1 ORDER BY `Ranking`.`sort_id` ASC, `Ranking`.`star` desc LIMIT 3330
6SELECT `Columnist`.`id`, `Columnist`.`title` FROM `columnists` AS `Columnist` WHERE `Columnist`.`id` = 1 110
7SELECT `Columnist`.`id`, `Columnist`.`title` FROM `columnists` AS `Columnist` WHERE `Columnist`.`id` = 1 110