SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001423s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 41093 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 41093 [ RunTime:0.001862s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87158,791688,806337,90221,363284,267180,163381,598060,695606,237103,902583,420122,251116,912094,655632,700699,638430,28147,189889,992718,687524,408045,987891,697975,786194,119724,317512,531291,367079,516615,46781,1000218,1046501,245772,939603,455273,104775,817783,635583,908190,170956,21420,295037,41713,985646,11336,481411,31611,401916,1042319,352095,424885,23109,61693,803541,189215,136805,451241,76936,734857) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001114s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 41093 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 41093 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]