SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001413s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 311578 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 311578 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (87084,241948,800119,281849,915843,121633,969881,851250,26854,686579,750519,221777,361032,860507,1013324,660693,24022,122201,110364,790315,311174,435274,90685,966134,892538,678622,884859,23762,883325,876755,461432,901742,144151,10340,840524,391633,574207,829540,650804,443675,295369,714435,912208,675649,1036612,975622,579560,810721,282196,879145,289394,543058,213676,38587,438554,63752,147208,623918,147891,886409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 311578 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 311578 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000597s ]