SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 493103 LIMIT 1 [ RunTime:0.000614s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 493103 [ RunTime:0.008265s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (539358,522700,220345,448461,942686,576841,801833,173672,986329,910411,109635,742880,129431,1006161,307639,990778,538790,751127,595401,396819,907331,461785,268812,907339,599387,454546,836108,419163,737070,817853,244981,473182,428752,839328,156636,739570,414363,778304,1025109,115579,1026420,588787,22933,1023426,327798,379157,1015410,594382,789854,126335,283616,444652,614439,371203,397804,618351,157672,358602,20314,973350) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 493103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 493103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000639s ]