SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001290s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 812019 LIMIT 1 [ RunTime:0.000411s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 812019 [ RunTime:0.001816s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (395015,679821,686211,813452,1045728,810537,915849,249392,475831,867629,1000297,881348,851757,116031,504830,330564,778132,245670,369101,267541,189292,485853,926353,767460,859561,250755,674794,301562,780906,484795,556397,711957,642237,319027,727701,949233,377846,520590,81344,987980,322089,197165,421555,175167,531771,533205,545405,688771,547590,244942,850570,210837,606432,913343,336309,981994,795676,519129,951267,931056) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 812019 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000448s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 812019 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]