SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001296s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 222834 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 222834 [ RunTime:0.001603s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98480,864541,932937,1011436,1030084,921723,1020334,637787,323098,189500,61704,840300,7120,801483,110352,1028804,645546,672961,990188,676102,260108,960490,348606,228608,1032905,961294,923223,373350,22903,751431,119312,722965,677109,708530,265089,710940,751920,426839,593976,330659,460909,1007611,499944,688057,30591,1015058,543750,668127,788756,936914,619502,582590,523330,147022,916313,375872,558262,697229,145362,977074) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001264s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 222834 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 222834 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000613s ]