SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1031374 LIMIT 1 [ RunTime:0.001358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1031374 [ RunTime:0.001505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (111659,944260,70918,91558,288853,126537,255800,734103,1021978,1034465,868195,817989,148709,287407,480800,978161,73920,132164,401849,298655,195126,520090,437374,551908,233440,334208,794253,261546,347397,852403,91661,944699,1028192,230948,993419,668551,597008,733301,847528,621572,35669,941662,247794,474039,51616,564254,486141,908723,120593,918110,888191,888997,980074,197579,901913,983004,1000062,340494,409218,635037) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1031374 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1031374 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001720s ]