SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001048s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042741 LIMIT 1 [ RunTime:0.000405s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042741 [ RunTime:0.001555s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629116,155819,7268,1011712,719138,861851,1044140,47822,1019929,344061,466060,67405,493947,760746,752216,54161,136204,547350,317369,399959,821119,155036,4482,852744,573003,585295,753201,397177,637004,759087,524297,758807,648209,730484,577733,442579,427956,144295,93885,705317,1030332,353329,494928,662471,711695,580331,636807,301152,821609,1038276,611042,55159,256803,436297,142597,403828,461508,648038,728635,1041236) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001479s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042741 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042741 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]