SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801015 LIMIT 1 [ RunTime:0.000365s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801015 [ RunTime:0.004183s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892359,510118,207978,700337,547019,399029,672080,3612,533964,475487,270400,37353,469250,1039850,442467,485946,268816,634410,764569,616900,1029958,1008384,277629,596093,203497,965688,767078,153235,242415,996251,111090,467794,271835,831896,755628,610193,911816,136334,765812,822443,387439,97309,452263,405747,507082,85862,1035627,581459,83387,253058,999816,488017,451619,876762,640518,513962,608382,565629,526277,882471) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000624s ]