SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 546223 LIMIT 1 [ RunTime:0.000339s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 546223 [ RunTime:0.001958s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (644974,653261,33716,224618,455402,960148,401703,217853,239701,340842,902575,410110,224641,684672,709413,1009921,785238,463071,803083,807337,693634,294211,271024,647743,69374,477466,37980,904115,191290,225647,614452,318855,311371,589175,912787,384686,606145,488867,814187,389115,129747,170675,40307,518611,134634,397937,1008024,976608,999842,656527,328819,944113,723017,83913,258756,291215,410401,816657,732977,826457) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001720s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 546223 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 546223 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]