SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001623s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 842509 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 842509 [ RunTime:0.001660s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (28433,723915,846794,14867,72737,466308,354745,647560,337032,359827,346318,57860,931654,542997,505825,1011732,968493,490171,627199,931905,893733,93045,293885,994908,870909,885294,999720,603988,62256,585345,84338,990851,697633,817671,770052,119132,191331,136173,491687,533008,318527,588838,481159,987905,956137,929270,263660,967174,733361,790114,455689,888204,663252,589659,604379,202096,555665,554497,913584,219093) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001298s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 842509 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002015s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 842509 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000539s ]