SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001620s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 27413 LIMIT 1 [ RunTime:0.000471s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 27413 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (854511,1020440,889802,883218,859680,232155,128183,547298,640367,370213,956184,394623,554475,82061,560152,264194,760447,492694,1013996,902226,506092,144841,811001,355095,859560,432203,15296,909590,679007,135056,108764,117347,217979,272015,621020,405091,814442,446238,1028534,295287,447751,794649,733536,361927,85955,303129,1020726,991117,342672,523568,564158,953200,35900,26693,105999,1036487,457928,255075,817633,660041) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001329s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 27413 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 27413 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000418s ]