SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 891743 LIMIT 1 [ RunTime:0.000313s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 891743 [ RunTime:0.002085s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (336704,210235,280190,368149,208096,681464,499683,511743,1016123,394640,287571,697959,744525,824365,33365,481901,799175,343764,466765,56143,878432,245083,1021661,904379,798891,355529,169792,525914,960792,158404,200876,171388,227913,105883,802649,136353,64437,641851,867859,603482,402924,553567,447420,104253,90134,39791,445904,702992,1025593,521406,222293,299074,443175,353398,731,744560,329511,141407,210472,252356) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002225s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 891743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 891743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000766s ]