SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001148s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1014459 LIMIT 1 [ RunTime:0.000308s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1014459 [ RunTime:0.002271s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (407053,440989,366501,674421,141325,154016,748387,119460,207090,809296,209907,625775,536145,610218,707661,268510,590989,669004,104433,263308,489005,922506,318848,636749,790479,556571,553578,548948,64971,559928,746560,853171,589313,1029389,487695,681823,617161,18449,234766,666294,118127,368481,834167,176105,772006,247871,858746,901571,78942,625869,831410,581950,219161,733029,1021012,343165,534719,836174,1009267,484614) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1014459 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000369s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1014459 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000454s ]