SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001188s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008906 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008906 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (506099,791318,601371,342943,648361,637585,643202,419634,114570,995002,253594,92716,892218,861866,500814,208346,744513,139545,316045,919650,705962,1040243,553220,845886,766865,80207,680318,421655,607803,424017,385880,137279,36033,294012,328689,921804,1693,653878,402875,498487,551341,407756,1003318,123308,969129,553200,672915,512038,298199,35870,788076,692086,782186,833416,127479,28270,894701,1003031,206342,643117) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001143s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]