SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1051 LIMIT 1 [ RunTime:0.000301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1051 [ RunTime:0.001774s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (229362,692381,208743,494094,531764,922570,29596,256036,237157,294963,52247,960838,396297,230326,788915,926769,439953,1007408,555217,648744,1003521,836330,612749,657515,72276,993958,497099,718817,1025803,816821,769794,845345,226827,893409,1008192,225963,740440,954506,508670,189528,834962,1025193,967241,780668,780169,768230,994909,713596,567427,454515,721611,271748,646186,1046898,733725,22438,743396,1033427,257776,34204) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1051 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1051 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]