SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001181s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549753 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549753 [ RunTime:0.001625s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (595764,897809,1014044,132866,135919,14616,631935,769724,178242,82209,450081,808399,323947,264698,559990,805449,39632,522100,1008579,645222,577426,812864,478017,125544,940299,937849,146053,442211,977690,653587,308706,661284,53068,270188,901404,54440,406709,511210,921477,398499,209044,923469,380000,382246,140583,421070,831814,473206,188364,1038164,496198,909495,519094,38596,973164,294751,525059,216881,1027663,93933) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001518s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549753 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549753 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]