SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508901 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508901 [ RunTime:0.003962s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (478448,426950,984699,13574,200502,185980,451811,484447,902279,393881,322606,800766,288397,95765,161887,934145,189470,612883,8546,996703,28737,354830,295616,751840,664865,589191,775158,396036,641025,181336,497790,123087,705384,297641,850377,894298,920475,723565,432458,26235,771249,322770,53999,367984,264261,824738,137979,253139,904071,543506,924106,701574,519228,868602,705836,192364,750952,783853,472729,817865) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508901 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508901 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000458s ]