SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001448s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 412902 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 412902 [ RunTime:0.002001s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (317831,652901,1042207,612739,358352,640394,57625,93687,527506,716698,702471,406699,1047827,858529,714287,794216,61671,562287,428791,124871,295284,509171,870900,746737,636438,363182,133387,681352,541187,823741,497833,609752,840009,710142,456276,490889,6803,229244,50837,757246,283287,433811,498546,236168,491414,389857,980349,965779,204866,510926,980848,691710,524226,43895,221109,246749,627005,213330,831593,220897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001175s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 412902 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 412902 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000495s ]