SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547041 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547041 [ RunTime:0.002018s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (629587,244832,512446,310500,962423,745149,246031,71990,853599,643185,636954,394389,406554,784262,61717,21403,777457,303369,1042254,714273,407450,979112,407947,507444,835317,874593,697593,707624,709852,358581,526586,998012,401047,883908,1047914,737093,149051,657014,535935,847898,151798,384344,623010,103602,90227,278974,45765,278777,662314,359022,9147,757076,343058,240094,301007,120917,544677,763195,156764,46262) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001784s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547041 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547041 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000628s ]