SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 510804 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 510804 [ RunTime:0.002123s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (830460,988885,194311,970529,37064,721958,742601,420310,1031969,508266,413620,997127,874237,785304,980991,574836,672201,99376,611473,820921,442296,336169,686170,449943,634026,39279,674258,144760,503654,183879,175057,708116,232781,648777,631107,40110,925786,427983,798051,624181,159879,299183,303853,638084,7994,531146,643751,327322,291083,569223,839077,605190,832841,554760,370389,465339,1037213,615347,938358,849927) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 510804 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000458s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 510804 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]