SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001643s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 200968 LIMIT 1 [ RunTime:0.002163s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 200968 [ RunTime:0.005730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (205606,754931,94835,465639,274700,758752,855844,17275,1043716,819998,880258,1027795,55112,588481,625159,821259,256525,55397,899344,148996,868301,162346,68,167649,857224,881030,874555,549667,834689,1032065,997791,367490,987350,166290,932834,499310,497301,603870,232494,661573,619369,705919,981612,580596,664463,347344,749282,685997,873881,580700,503541,51780,1016174,773418,565439,134039,1010930,430799,938868,871593) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007819s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 200968 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003077s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 200968 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.004362s ]