SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 526890 LIMIT 1 [ RunTime:0.000434s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 526890 [ RunTime:0.002079s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (123054,928136,808734,885163,374822,171426,710646,294123,625093,735316,688049,163786,429042,170748,539668,481310,563000,418010,272479,217236,820146,352170,297561,531447,1016065,527511,600374,185814,640290,821595,177309,812150,1010625,3065,501467,889540,398969,476070,1029331,578929,817612,750855,69352,814337,174885,67485,249855,192212,247487,46836,788780,499690,252242,85811,541669,288673,212575,105928,182884,926104) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 526890 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001130s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 526890 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]