SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001337s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404567 LIMIT 1 [ RunTime:0.001078s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404567 [ RunTime:0.004570s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1039105,418187,650458,985804,408778,346919,118832,524791,751088,502944,111650,439602,401907,897777,496684,56620,681442,63696,255224,329593,520152,416273,19072,18635,770055,728129,97363,838956,393772,51546,872409,903235,308560,858294,607001,5450,809533,235179,20582,274463,401163,847401,364040,622110,166736,610731,776123,1031622,147603,446240,283689,800985,909950,572081,382607,770385,461585,830001,931010,82269) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404567 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000392s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404567 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000566s ]