SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001179s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039681 LIMIT 1 [ RunTime:0.000472s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039681 [ RunTime:0.003252s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (757820,528518,111660,1002224,855986,967996,697067,96299,831875,543758,402892,145705,278885,812175,432483,790055,761630,228092,745785,518145,864762,725379,869407,54261,269857,369412,956288,934746,560225,197489,930987,308020,314357,399300,287120,72113,374824,964339,934098,675346,559698,922066,921128,518322,604206,448998,670678,729723,58408,264620,129409,818292,363976,934970,445478,643432,311882,159160,629482,389717) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002570s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000670s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]