SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542993 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542993 [ RunTime:0.001696s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1010619,46145,107449,398425,824800,568064,136842,325615,119548,98778,915077,973866,526546,713490,665859,78771,794053,583171,16641,674942,317815,945400,419089,814223,635382,104829,894620,924763,338389,933494,451005,1035635,603279,512370,513283,979653,99012,192728,11623,359682,329025,990845,983386,268418,373171,86351,951762,717264,627897,581047,61823,706077,835123,619325,18278,750044,602547,880257,501506,208060) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001283s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542993 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542993 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000515s ]