SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001222s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549710 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549710 [ RunTime:0.001672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (775326,528977,191069,243595,727983,245183,254834,178750,286442,276386,121518,769624,653602,68725,431190,330381,456805,142822,1032918,799946,797794,336116,326445,787313,125865,712412,727891,290384,494015,810767,76487,942443,563411,699147,880206,716700,491018,165782,615893,102128,949831,427854,1034973,385215,241268,171030,591564,785973,529368,79598,248074,145012,336066,918669,194118,74836,42859,966678,193866,534582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549710 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549710 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000675s ]