SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498398 LIMIT 1 [ RunTime:0.000333s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498398 [ RunTime:0.001647s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (647358,826507,407928,421441,840496,1023307,558763,189302,271539,1003403,922409,629317,77541,615012,921583,681968,386127,680936,540255,520489,373486,652363,541168,245159,373162,1038973,352469,983329,951960,937090,938427,97382,988151,29815,711708,662963,118326,702147,23930,999033,585364,256561,1964,489666,453441,253147,1044648,477631,1011008,250214,605241,915433,259992,214606,975135,559782,369738,639182,973671,131570) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001001s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498398 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498398 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000400s ]