SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001189s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003906 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003906 [ RunTime:0.001666s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (502590,72558,288861,337686,625201,728695,208785,141213,1046457,588213,93009,42903,1001185,218745,721236,839135,186868,171627,520479,530614,931684,367813,490331,556695,757060,482794,828518,201350,115707,819614,318626,330544,684880,245635,129052,710117,1018568,1016189,792659,333657,1023716,501769,165221,269348,814351,82310,316929,903902,269167,327240,456102,474316,117249,800072,525387,664280,998624,58141,307830,487770) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000331s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000427s ]