SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001725s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026513 LIMIT 1 [ RunTime:0.000933s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026513 [ RunTime:0.003261s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (640233,583463,865020,909866,671468,915451,150760,364375,657702,952905,831344,164628,1033440,245591,1046283,391390,969571,544899,522567,654534,630093,868724,150612,848983,492228,627706,755514,72779,442524,142838,1030465,802228,841341,378234,761775,174119,857073,1018669,995401,389847,892506,838370,30059,540533,30700,762806,210787,413747,711440,983580,193112,896352,12707,730085,959271,628118,428563,115138,210991,913452) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001503s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026513 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000422s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026513 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000849s ]