SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411765 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411765 [ RunTime:0.001870s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69952,526974,1034062,488508,1025359,793149,362885,757056,807016,190489,616205,393389,194292,586835,863379,336921,1035627,880483,158141,462114,242703,981607,1035362,613669,143102,418855,869946,714487,85898,76999,423415,967615,785473,443214,19286,249861,480196,301835,597032,312653,290604,623347,1013160,138908,497834,76564,780513,864211,642698,936149,205683,580251,533301,1025772,54150,403562,233784,771210,454513,1013669) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411765 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000319s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411765 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]