SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001228s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 425543 LIMIT 1 [ RunTime:0.000535s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 425543 [ RunTime:0.007069s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (467174,155732,893742,1028749,1012053,171568,368014,578716,810521,817472,922831,110518,422735,435618,17910,492364,43198,539842,1438,813976,513978,503441,164756,208077,1011630,908729,949098,434977,296415,274564,689812,228006,381608,850724,899322,375932,636535,769033,371629,163861,877850,387532,328399,727554,360587,657705,346242,532456,738860,649299,83747,431441,454880,578941,925611,173918,510902,460468,202460,438160) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003730s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 425543 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000731s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 425543 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000552s ]