SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002165s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 324091 LIMIT 1 [ RunTime:0.000394s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 324091 [ RunTime:0.001918s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576025,77406,12983,898229,31032,498559,400686,740918,1014135,476643,649406,708773,172157,402011,669858,1040948,394845,225281,261683,182027,390141,465391,825499,207903,544213,422159,600470,887658,289324,503781,885585,718310,121415,1023852,944116,284660,437668,331634,1016603,955011,301465,412383,395284,1003979,98211,142735,913415,620386,52554,759030,77307,425743,20704,649471,759893,718031,91012,134482,1037226,814901) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002187s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 324091 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001343s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 324091 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001221s ]