SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001415s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 587812 LIMIT 1 [ RunTime:0.000453s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 587812 [ RunTime:0.001919s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (315286,845269,447614,153066,996793,422979,903937,172188,646793,208162,18242,936128,750562,90742,822062,49474,934955,560076,956845,1026449,416180,14424,609149,701702,197716,683282,670508,81251,350743,537720,847652,322780,1010196,634381,108652,548025,348411,202122,561899,448674,326964,589846,593358,311053,520980,588816,857207,517059,193669,728022,420606,1035536,851845,420538,232581,316444,668140,919919,974763,265984) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 587812 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000495s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 587812 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001126s ]