SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001455s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 575441 LIMIT 1 [ RunTime:0.000575s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 575441 [ RunTime:0.002394s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (714364,355495,163943,684983,605694,265450,208890,183358,731790,333975,491625,442162,513492,127471,656992,697584,893201,93056,238690,997579,878188,103020,329125,448819,854264,314727,234158,726551,780454,516804,775161,320392,879523,443577,477321,74281,432747,636019,90167,980638,20702,850158,765863,171908,97929,322045,701995,62483,429045,64312,412166,205698,502850,288124,1044996,49126,554287,730050,118716,233186) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 575441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 575441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000573s ]