SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001332s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 986504 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 986504 [ RunTime:0.001835s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (35259,17708,865446,545934,431818,762694,394286,662965,439579,664005,113146,672699,895743,351734,360042,474262,209685,1014829,967944,67892,627523,409648,192483,43912,577491,884492,837733,103865,733366,729592,802460,184422,949653,803735,895180,60271,1033346,761013,50252,210634,375875,932565,488029,851615,451814,278032,744433,62499,885840,910012,1033653,373193,931282,624882,723619,551203,97144,423467,964848,403256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 986504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 986504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000751s ]