SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 100438 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 100438 [ RunTime:0.001523s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (867447,286562,685779,82965,427419,663406,355688,572723,791641,610635,550731,296038,177735,522284,748040,538420,77576,380456,417681,497257,849637,711089,200176,629071,396986,117254,319423,831046,269633,505028,1038654,336511,612275,20556,678793,911612,501480,124976,578081,446175,618221,570234,992869,493047,648047,709381,197645,230559,52143,164155,746878,359791,988009,202210,768883,964730,510669,112146,662786,964283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 100438 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 100438 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000672s ]