SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 506768 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 506768 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (70373,340581,554798,334072,775217,462375,372362,536063,764726,328530,528978,200119,94088,596702,199355,794474,502357,987608,782260,338994,778391,729974,161901,654210,468054,344143,505968,900536,177852,180205,674720,889882,1015101,150169,488909,1022276,612630,727747,210359,809294,642001,129434,528254,1043276,130330,684476,240671,886434,115551,107065,114108,137349,559229,377894,604762,707404,236353,626697,211744,188086) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 506768 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 506768 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001148s ]