SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002194s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 322943 LIMIT 1 [ RunTime:0.000519s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 322943 [ RunTime:0.002978s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (504341,138237,559683,438576,601997,485161,4339,374637,16101,898971,617783,799704,434633,419260,285392,522847,645744,595105,296216,709603,1003223,230507,361568,21902,312376,630179,471289,284864,781501,338943,280414,260393,571308,866087,924799,767765,662092,724431,822064,783163,813356,507266,465254,497691,531547,29440,938749,946800,440520,394651,70641,577307,345705,935179,745523,796464,521723,905957,6138,831788) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 322943 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 322943 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]