SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002295s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549852 LIMIT 1 [ RunTime:0.000395s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549852 [ RunTime:0.001510s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (342552,95596,666934,218686,854412,290624,485987,366603,169581,1048297,364632,712999,841280,837137,607170,150538,231520,709331,591015,488836,244365,50252,897765,122698,92635,404545,530402,72647,93561,572964,47928,852142,385893,392682,317158,16101,1036061,123448,387346,977087,12506,118642,406156,1016597,485129,683254,1714,313887,490654,910968,98210,48047,676771,683244,979986,958788,497343,955139,426227,161616) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549852 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549852 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001217s ]