SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001258s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 498612 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 498612 [ RunTime:0.003736s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (632354,530494,250994,117125,825045,846460,670570,368368,739431,911044,239709,99322,856184,86215,407819,520368,724816,968175,299994,1042099,832346,279242,896665,126309,633099,799079,608446,956113,157441,95021,696663,909861,743752,556427,756542,299807,773543,84296,538060,260381,1036344,315088,219528,252111,341486,613982,405347,624739,223011,206036,322018,925050,816902,117651,155075,614793,12427,935615,616831,663846) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001429s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 498612 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000606s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 498612 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000478s ]