SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001992s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 420681 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 420681 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (601618,50459,112908,36954,902664,395762,204440,760288,792655,605248,949299,458516,117924,631201,916577,532790,343216,173782,196968,169478,178401,981282,2686,7254,404179,839578,576951,323457,1013216,329686,69817,956689,309161,579349,940914,1003417,217920,940446,945338,316902,463337,1011001,801678,637144,508071,402392,132552,409368,141857,159631,509337,501022,345981,813725,104486,786003,103309,439405,805964,900863) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001072s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 420681 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000376s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 420681 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000706s ]