SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001287s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261754 LIMIT 1 [ RunTime:0.000440s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261754 [ RunTime:0.001500s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576271,801864,791256,787213,520533,244736,1041713,296365,710118,99500,349942,344514,958696,609736,707954,931018,874544,32202,866734,736853,726980,531123,454087,512749,274501,639410,643773,233278,806841,553863,21207,155604,924630,592120,665319,428398,891929,449425,982654,382638,515641,353339,584088,274214,570406,1011642,891708,274589,779308,488120,325698,33699,803805,389308,506435,317588,714280,336607,112914,246843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001073s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261754 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.003127s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261754 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000561s ]