SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 281224 LIMIT 1 [ RunTime:0.000568s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 281224 [ RunTime:0.001699s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708220,27074,388701,1016725,481771,1048644,879075,604444,661226,348934,105325,184892,121551,243743,704319,304914,653291,92022,749414,199291,639466,95101,1007846,166195,25952,540405,163315,971430,666520,495649,97578,152148,600260,740663,19704,577010,525169,665979,776109,433604,644719,667842,666743,137218,1002017,178437,337436,795011,875740,883263,939320,1012178,458976,408515,44385,133707,640344,381427,553612,941019) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001113s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 281224 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 281224 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]