SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001509s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 6894 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 6894 [ RunTime:0.001845s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207096,247411,57764,418419,205766,388463,878493,717602,611137,260264,110947,517708,609991,659300,265407,373117,378638,476585,770412,1034867,68278,836478,173124,274343,350750,113400,910572,392583,1010288,683984,932045,484869,55853,83045,500535,263548,981910,67735,221804,680576,305336,823070,349391,254774,150101,676953,988578,177920,825414,795251,127378,281837,724891,207327,177760,199659,290853,525862,749453,227033) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001327s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 6894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 6894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]