SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 112841 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 112841 [ RunTime:0.002020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1032621,586179,386635,623207,162012,271999,389078,953082,260310,226053,747102,435780,1032704,583849,591020,98,390675,867820,529244,473479,840482,69726,978250,223113,438934,56174,970523,1040124,869834,36773,566327,793041,283970,164030,326590,749737,222107,853389,551579,651184,384265,672155,433787,604441,501219,606170,436976,118963,847241,675818,858142,450590,471426,303942,964791,382142,969644,526223,867755,93582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 112841 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000341s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 112841 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000644s ]