SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001209s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 59628 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 59628 [ RunTime:0.003107s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453280,462660,870385,114544,448678,297230,288037,461783,178800,620770,815246,558557,252153,1020030,494793,852896,63737,882124,311663,236612,193858,577728,562862,545156,654307,897080,387631,239986,960603,828090,410838,551545,389659,894098,591940,955194,668929,436872,399212,851315,581087,20538,364116,480637,1033513,484787,14704,32105,12385,841393,557096,345699,280830,977881,401854,1043649,138084,838551,1019933,1018583) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 59628 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000451s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 59628 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000788s ]