SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001411s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 982851 LIMIT 1 [ RunTime:0.000545s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 982851 [ RunTime:0.004546s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (98667,940966,627271,1021608,300758,695316,896618,330655,908084,10556,621383,606063,105130,334225,520779,738495,440989,508341,754819,989308,163092,547455,414647,662041,74226,714626,134861,953568,960484,332503,530293,192819,153380,719606,106296,539887,446576,869237,467371,1027417,922951,351830,175342,950443,721104,477999,268181,32893,83758,419758,258780,278432,947694,26478,467301,759019,946732,530505,234635,423681) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001529s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 982851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000547s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 982851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001482s ]