SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001302s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 452263 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 452263 [ RunTime:0.001991s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427482,333113,1005061,947167,408985,425317,187078,863304,298747,536184,731493,560783,211812,787948,846196,204535,133488,886677,341316,693722,258040,101030,243212,389767,859623,361912,781900,389046,873406,725569,1026316,925160,171687,58675,502528,876209,913041,405131,202687,365783,679151,648075,103484,911648,800835,380585,193652,382098,818784,75487,735919,920386,702705,7842,1043355,793514,413661,216855,527480,808404) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001342s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 452263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 452263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000453s ]