SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001153s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046825 LIMIT 1 [ RunTime:0.000314s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046825 [ RunTime:0.001801s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1014018,305764,28147,226093,401486,108697,787461,343808,778934,465912,876501,744718,543043,394816,510566,224684,867564,984188,588569,211923,280969,83276,951892,500680,96867,398808,923324,189925,506070,338378,961155,553787,800520,242258,279196,277214,135839,358308,827234,1022499,678801,622078,515644,11348,616308,305985,641798,789919,630083,71458,258250,429518,515865,114202,156897,600435,216104,954494,906683,73567) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046825 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046825 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000671s ]