SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001166s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009116 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009116 [ RunTime:0.001768s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (716464,735787,842567,132556,1030331,256880,1010904,344806,620780,315542,1034455,662526,786063,507679,401611,337059,244040,653727,776802,31825,723995,321836,158451,1046908,71623,635435,93247,460492,178447,543798,520431,695634,613402,1045796,105904,259747,934636,402406,206467,429881,593744,402073,989662,778353,1017270,451067,387823,458700,929451,1001070,1009189,817906,162720,575167,571527,91302,47254,279069,979690,162166) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009116 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009116 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]