SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001277s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311475 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311475 [ RunTime:0.001729s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (196111,1045428,32839,577041,362185,744149,879377,628151,237076,973662,330180,897679,193649,964832,249314,404828,448334,431018,147042,971034,150210,21203,1014585,17501,775105,392130,848174,212697,677589,456326,137171,114892,102176,510605,613533,325419,544683,43627,629386,722691,536355,975737,579621,1010333,978147,251851,919158,137047,131335,408475,800659,560858,104402,142824,509022,522520,58407,487551,772651,423080) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001021s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311475 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311475 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000500s ]