SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 336599 LIMIT 1 [ RunTime:0.000273s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 336599 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (383140,696414,467490,311178,677879,660951,650666,555138,675290,545141,907431,696994,703707,472283,908917,899237,825726,677922,846287,765273,39400,32355,166048,176733,203605,481541,31925,746639,437693,183254,132932,56103,724434,517414,982502,281353,49693,345771,744572,302838,1032622,580204,239695,715036,134001,535448,196929,634285,955438,829849,291300,288988,374547,815458,867004,516184,809589,1025695,345898,680360) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001092s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 336599 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 336599 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000386s ]