SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 536527 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 536527 [ RunTime:0.001595s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (635548,684741,846429,879800,325407,454728,418932,1023124,142586,727574,140570,931978,840529,370081,73344,72437,502633,167289,255703,193205,284718,720703,65418,113143,919731,503972,917575,17617,678874,609341,148365,515566,628166,567435,345795,613477,316220,559020,7594,284697,357776,712589,558205,157967,4019,474296,706100,39803,84516,855797,189849,995851,762899,36898,87576,1011478,102838,146154,454801,113962) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001714s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 536527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 536527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]