SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002897s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 554267 LIMIT 1 [ RunTime:0.000349s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 554267 [ RunTime:0.001551s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (115378,332811,974930,175110,923041,855466,205750,11433,836889,471419,287878,2495,619823,572315,838228,759863,69063,117934,681440,605371,888954,960031,626516,484889,549343,170896,1002791,624154,869593,729455,426151,846490,343346,1006781,246117,492969,728982,344776,493085,446675,641288,873794,81304,855076,328955,949516,56096,65842,725095,641220,833562,337342,238086,437272,57941,374776,271009,586786,733242,716491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001101s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 554267 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001152s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 554267 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]