SHOW FULL COLUMNS FROM `bg_settings` [ RunTime:0.000621s ]
SELECT `key`,`value` FROM `bg_settings` [ RunTime:0.000298s ]
SELECT `value` FROM `bg_settings` WHERE `key` = 'front_locale' LIMIT 1 [ RunTime:0.000252s ]
SHOW FULL COLUMNS FROM `bg_categories` [ RunTime:0.000562s ]
SELECT `id`,`uuid`,`parent_id`,`name`,`slug`,`description`,`sort` FROM `bg_categories` WHERE ( `status` = 'published' ) AND `bg_categories`.`deleted_at` IS NULL ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000403s ]
SHOW FULL COLUMNS FROM `bg_brands` [ RunTime:0.000532s ]
SELECT `slug`,`name` FROM `bg_brands` WHERE ( `status` = 'published' ) AND `bg_brands`.`deleted_at` IS NULL ORDER BY `name` ASC [ RunTime:0.000288s ]
SELECT `key`,`value`,`protected` FROM `bg_settings` [ RunTime:0.000334s ]
SHOW FULL COLUMNS FROM `bg_article_tags` [ RunTime:0.000516s ]
SELECT * FROM `bg_article_tags` WHERE `slug` = 'メガネ' LIMIT 1 [ RunTime:0.000297s ]
SHOW FULL COLUMNS FROM `bg_articles` [ RunTime:0.000503s ]
SELECT * FROM `bg_article_tags` WHERE `slug` = 'メガネ' LIMIT 1 [ RunTime:0.000275s ]
SHOW FULL COLUMNS FROM `bg_article_tag_relations` [ RunTime:0.000554s ]
SELECT `article_id` FROM `bg_article_tag_relations` WHERE `tag_id` = '12' [ RunTime:0.000509s ]
SELECT COUNT(*) AS think_count FROM `bg_articles` WHERE `status` = 'published' AND `id` IN ('5','7','8','9','10','13','14','15','16','18','20','21','22','24','25','26','27','28','30','31','32','33','34','35','36','37','38','39','41','42','44','45','47','48','51','53','54','55','56','57','58','59','60','61','62','63','64','65','67','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','87','88','89','92','93','95','96','97','98','100','101','102','105','108','111','113','114','115','116','117','118','119','120','124','129','130','131','132','133','135','136','137','138','140','141','142','144','145','146','147','148','149','150','156','157','158','159','160','161','162','163','164','165','167','168','169','170','172','173','176','177','179','180','182','183','184','187','188','189','192','193','194','197','199','200','201','202','204','205','207','209','210','212','214','217','218','219','220','221','222','223','228','229','231','232','234','235','236','238','239','240','241','243','245','246','247','248','249','250','251','252','253','254','256','257','259','261','262','263','265','268','269','273','276','277','278','281','284','285','289','291','292','293','297','304','305','306','307','308','310','312','313','314','316','318','320','321','322','323','324','327','328','330','331','332','334','337','338','339','344','351','352','354','357','358','359','361','362','363','364','365','377','379','380','381','383','387','388','390','391','392','395','396','398','404','405','407','411','412','413','415','416','418','419','420','421','422','424','425','426','428','430','431','432','433','434','436','445','448','451','452','457','462','464','466','467','468','469','470','473','474','475','478','481','482','485','487','488','489','491','492','493','495','501','502','503','504','506','511','512','513','515','516','517','519','524','527','528','530','531','532','533','535','538','540','542','543','544','545','547','548','550','553','554','555','557','565','567','570','572','573','575','576','579','580','582','585','588','591','595','597','598','599','600','605','607','609','610','611','612','614','615','621','622','623','625','627','628','630','632','635','636','638','643','644','645','646','648','649','651','653','654','656','661','662','664','667','668','670','671','673','675','676','677','678','679','682','683') [ RunTime:0.002193s ]
SELECT * FROM `bg_articles` WHERE `status` = 'published' AND `id` IN ('5','7','8','9','10','13','14','15','16','18','20','21','22','24','25','26','27','28','30','31','32','33','34','35','36','37','38','39','41','42','44','45','47','48','51','53','54','55','56','57','58','59','60','61','62','63','64','65','67','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','87','88','89','92','93','95','96','97','98','100','101','102','105','108','111','113','114','115','116','117','118','119','120','124','129','130','131','132','133','135','136','137','138','140','141','142','144','145','146','147','148','149','150','156','157','158','159','160','161','162','163','164','165','167','168','169','170','172','173','176','177','179','180','182','183','184','187','188','189','192','193','194','197','199','200','201','202','204','205','207','209','210','212','214','217','218','219','220','221','222','223','228','229','231','232','234','235','236','238','239','240','241','243','245','246','247','248','249','250','251','252','253','254','256','257','259','261','262','263','265','268','269','273','276','277','278','281','284','285','289','291','292','293','297','304','305','306','307','308','310','312','313','314','316','318','320','321','322','323','324','327','328','330','331','332','334','337','338','339','344','351','352','354','357','358','359','361','362','363','364','365','377','379','380','381','383','387','388','390','391','392','395','396','398','404','405','407','411','412','413','415','416','418','419','420','421','422','424','425','426','428','430','431','432','433','434','436','445','448','451','452','457','462','464','466','467','468','469','470','473','474','475','478','481','482','485','487','488','489','491','492','493','495','501','502','503','504','506','511','512','513','515','516','517','519','524','527','528','530','531','532','533','535','538','540','542','543','544','545','547','548','550','553','554','555','557','565','567','570','572','573','575','576','579','580','582','585','588','591','595','597','598','599','600','605','607','609','610','611','612','614','615','621','622','623','625','627','628','630','632','635','636','638','643','644','645','646','648','649','651','653','654','656','661','662','664','667','668','670','671','673','675','676','677','678','679','682','683') ORDER BY `published_at` DESC,`id` DESC LIMIT 0,12 [ RunTime:0.002166s ]
SHOW FULL COLUMNS FROM `bg_article_categories` [ RunTime:0.000544s ]
SHOW FULL COLUMNS FROM `bg_article_category_relations` [ RunTime:0.000382s ]
SELECT `bg_article_categories`.*,`pivot`.`article_id` AS `pivot__article_id`,`pivot`.`category_id` AS `pivot__category_id` FROM `bg_article_categories` INNER JOIN `bg_article_category_relations` `pivot` ON `pivot`.`category_id`=`bg_article_categories`.`id` WHERE ( `pivot`.`article_id` IN ('683','682','679','678','677','676','675','673','671','670','668','667') ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000489s ]
SHOW FULL COLUMNS FROM `bg_media_assets` [ RunTime:0.000571s ]
SELECT `id`,`path`,`disk` FROM `bg_media_assets` WHERE `id` IN ('3018','3016','3010','3008','3007','2829','3005','3003','2999','2998','2994','2993') [ RunTime:0.000354s ]
SELECT `id`,`name`,`slug` FROM `bg_article_categories` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000260s ]
SELECT category_id, COUNT(DISTINCT article_id) AS c
FROM bg_article_category_relations
WHERE category_id IN (4,5,6,3)
GROUP BY category_id [ RunTime:0.001676s ]