SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001379s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 509640 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 509640 [ RunTime:0.002664s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954576,166840,965883,537964,223334,566200,594734,92110,81921,1024913,733227,987377,579071,791899,178126,583387,282507,241279,847438,342253,814103,588770,39253,271844,531748,455991,261399,200253,918017,497990,652032,795643,598633,892067,178860,491245,893363,617911,774176,511228,746031,887043,402858,591080,217646,126342,294430,18867,603222,903879,639480,300129,599507,497916,41874,780871,83328,878764,29468,151034) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002153s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 509640 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000864s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 509640 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000522s ]