SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001536s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555851 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555851 [ RunTime:0.001697s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (616489,163335,206653,483530,580664,177623,181957,532181,914768,621096,72572,414459,361907,917765,330107,804375,110144,1015697,798431,985016,218333,779895,496035,411750,202382,232395,514362,251634,801320,885932,151380,455717,1036938,966108,620454,911360,896091,70205,113718,34129,148318,577705,129255,111292,658447,661975,606483,315008,836374,557669,662398,356740,836971,318986,57874,686875,574265,90128,431130,374691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001172s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000442s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000642s ]