SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001260s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 511883 LIMIT 1 [ RunTime:0.002124s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 511883 [ RunTime:0.005798s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (17159,97303,229379,865384,780656,996480,666719,575458,738989,428031,356309,410899,412959,795996,893972,1003346,478330,595916,697511,787636,987920,70936,841155,969246,573969,876622,525898,667289,684200,597162,13647,32447,698943,410145,323360,1043971,847899,857229,393724,426258,269138,214053,1248,235145,260347,92017,355041,11727,517635,783070,341533,801474,79428,225287,310532,273381,144331,885594,79166,923588) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.007189s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 511883 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000958s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 511883 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001758s ]