SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001119s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1040845 LIMIT 1 [ RunTime:0.000294s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1040845 [ RunTime:0.001837s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (437823,682995,72272,158903,632195,263574,581592,581459,570129,10225,949438,84913,827293,601098,607330,497032,300582,733746,180725,506154,819146,627973,210241,648009,623002,297850,421561,897285,946315,445359,584960,372072,862984,169875,214385,727524,706437,1025800,627312,631646,729024,209356,818512,260033,595354,1003062,630001,174994,639585,477881,761725,610740,424470,244801,1047273,924084,196301,271378,353512,891266) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000991s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1040845 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000330s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1040845 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000393s ]