SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 674583 LIMIT 1 [ RunTime:0.000306s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 674583 [ RunTime:0.001634s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (42389,680112,241111,435520,574638,558689,809043,400694,484198,29791,94991,469075,469057,696726,651392,453907,981586,696694,80568,338864,690958,939675,532426,1014557,330739,24584,388629,22406,221822,483036,715047,225100,1004140,908877,678831,825642,444152,915761,203004,420458,923288,423716,946095,189144,613063,701782,92165,962705,916121,23609,256878,702640,329448,603192,452242,45085,658836,71765,330169,454319) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 674583 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 674583 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000519s ]