SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026289 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026289 [ RunTime:0.001838s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (908345,263792,707098,109881,753122,170130,982048,656806,205712,629791,198130,289615,835995,31964,995253,793117,615174,234326,319854,750833,883970,733695,644482,713722,149512,352318,408183,392029,184891,853070,677337,258385,796302,726267,909230,21096,258868,243094,302584,460387,419721,544999,168517,367263,644316,518219,463608,183059,863236,133619,385320,131297,1018607,33379,1043906,724802,986025,897576,945649,567218) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000877s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026289 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026289 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000430s ]