SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001291s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1017543 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1017543 [ RunTime:0.002436s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (431048,357040,768046,385833,582124,321832,783736,581315,676683,206888,804968,465249,1040517,1002952,910525,702033,940560,167923,252180,259741,438960,432899,73848,349011,138658,702352,378532,674792,1031000,674784,265794,506869,645077,784800,172424,1038547,799800,87086,761845,105360,95985,420402,135607,42054,420134,230353,335022,272459,924352,381730,1013024,384276,803251,895101,293378,868876,316008,739484,1011195,364712) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001182s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1017543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1017543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]