SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001437s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 351109 LIMIT 1 [ RunTime:0.000418s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 351109 [ RunTime:0.003611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (221649,447395,375807,660401,542709,221867,665346,694493,781022,750969,435507,174380,69284,30543,373626,1039709,471253,181457,196160,854406,346659,749565,83839,39757,90962,483933,161492,629697,688842,246718,999305,531390,863060,257331,805627,471016,874325,981293,708759,565776,100877,911355,1003183,478553,277613,774809,128900,662597,876966,95092,550425,706985,504301,810234,729828,381300,875979,250827,605845,789691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001213s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 351109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 351109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]