SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001307s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020394 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020394 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156992,510366,336597,453745,978161,1015647,89208,129268,507152,396100,1031967,874093,379401,808774,786011,726739,303239,145024,359937,667105,425238,992365,307800,105794,162356,953366,336034,977346,751260,639773,121614,649438,612663,601120,778228,441542,973850,68508,156167,800515,964264,805005,492524,22621,703665,1006436,499006,361729,93102,204382,100592,100550,34380,279806,877411,383299,513035,21055,191969,371407) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020394 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000418s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020394 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000388s ]