SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003051s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 149320 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 149320 [ RunTime:0.001961s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (549813,520178,573464,78741,502476,609476,967073,778436,684972,675060,851415,251647,400814,517362,922648,500154,150662,238461,240370,1043568,839694,832170,885400,495150,231587,729367,294685,1013840,769330,67823,13062,302922,223111,717911,981402,600376,860893,580835,265166,776120,801546,812960,412783,762503,252222,343011,547963,940972,865722,38942,161534,66668,412510,585271,90128,429313,439766,665078,624374,144021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 149320 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 149320 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001163s ]