SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 514553 LIMIT 1 [ RunTime:0.000330s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 514553 [ RunTime:0.001892s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (220209,336514,897281,750898,42637,692225,403246,490910,796060,766085,1038421,386918,1029052,393347,866561,173975,183062,237011,918299,33348,1025003,759159,536472,657127,31676,151267,847769,632342,1047324,618023,768170,449052,383174,1010252,207562,652930,689385,136230,800319,967651,628209,877894,310654,918020,779285,424310,845167,624302,548215,129852,384803,872884,339506,239039,121479,858082,949439,754952,542253,9850) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 514553 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 514553 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000627s ]