SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001147s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201485 LIMIT 1 [ RunTime:0.003301s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201485 [ RunTime:0.002599s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103468,561349,429317,77046,264972,648408,561834,611080,247185,986003,453120,708328,791512,62293,209151,759102,454072,855416,117098,47905,367057,781448,36349,1017013,556995,148012,631705,86219,662254,398416,422917,95697,449014,511197,168762,916523,693044,765428,685363,308669,302757,835788,237703,736357,1044706,185229,912280,360906,235131,997870,853934,484726,121113,426066,964324,720537,601959,218413,317805,388253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201485 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201485 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000410s ]