SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40029 LIMIT 1 [ RunTime:0.000386s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40029 [ RunTime:0.004060s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (122611,656602,299644,354370,573843,975915,827034,846559,1020680,418304,100941,167710,997559,248893,65731,484351,643351,586677,155799,785129,979312,223116,456482,401107,456307,499610,660981,884469,873961,434241,594566,920645,879416,632763,325038,329241,716685,903819,632600,940690,273275,246037,361654,1008022,434485,946979,295090,1015798,265300,543157,394192,371853,637226,998752,185610,965142,598068,518810,51155,1024441) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]