SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 522640 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 522640 [ RunTime:0.001740s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (615513,881312,257666,79640,768048,894744,335915,991760,947513,235528,1009417,943262,317317,509227,264742,1041125,792320,62898,495374,246605,784012,776228,689072,654986,634480,17096,1034723,616797,170037,395987,256315,474658,691731,282954,77452,770754,960320,283996,127284,669534,1012157,313866,801478,44342,1035828,622955,456232,981770,607298,839066,403743,275178,263977,464291,311143,235833,777662,1000099,775479,897487) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000979s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 522640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 522640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000827s ]