SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452517 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452517 [ RunTime:0.002480s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039415,300246,576096,704586,41908,349823,807100,718095,345010,959806,66380,302410,759586,351474,203485,105055,37363,343478,416828,755100,982960,196390,894108,632051,695627,34498,1032144,747236,46831,84400,1032213,12517,335633,936339,634046,857320,861158,272156,7370,837478,158534,480348,663537,601441,442896,393805,210443,943786,424941,363987,811710,645464,144281,639134,1034216,600138,531055,204579,234957,702846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452517 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452517 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000722s ]