SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001227s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 566184 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 566184 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (495693,766369,202844,56915,739631,466372,143401,36811,436357,208182,420687,310435,47092,374111,1033956,720783,9589,761062,619012,242235,38725,137324,267546,8225,490845,49450,167407,651993,514283,40194,931218,503521,826251,481705,282114,1008101,90677,861313,932484,33771,563833,416910,893558,975725,99339,19044,129855,755831,171320,370265,948276,714474,66913,687782,814432,449561,485023,920187,691008,298735) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001131s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 566184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 566184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]