SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001322s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 481044 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 481044 [ RunTime:0.001494s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (353194,767799,182618,827614,768924,467548,690591,822179,342654,741886,518428,618166,482045,519394,888910,455427,419379,382125,212088,877921,431210,416367,575576,347568,637967,147816,320054,90880,396013,565349,570722,219254,66600,525567,943335,527135,869189,598793,397329,215294,701797,430905,85206,366412,301251,122290,581896,552556,420220,824527,200684,265796,100085,366971,167998,300472,276080,380555,711673,12253) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 481044 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000427s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 481044 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]