SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002484s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201582 LIMIT 1 [ RunTime:0.000329s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201582 [ RunTime:0.001900s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (400813,223064,68031,419671,624195,825939,89130,602116,66475,895441,136009,396510,389312,626,700167,900893,1023119,527230,222352,610348,174445,33633,500123,633191,473990,756636,215227,519328,856610,443427,663535,937014,273172,687455,34958,40575,279817,1039091,536899,818444,720227,292696,349819,942676,717300,744241,135544,719649,914856,972218,356428,414908,585739,162815,1046549,942324,322979,819796,1000015,931049) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201582 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000354s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201582 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000491s ]