SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 113686 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 113686 [ RunTime:0.001476s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011267,87497,264324,453460,630618,841169,328004,934259,351985,711326,291267,593614,26819,760992,3399,635030,897599,309749,530441,73293,164666,89458,1048890,112460,993999,491455,888024,1041026,736928,60920,923093,268519,252569,785225,609787,539346,594509,219989,657788,920733,201661,642157,686000,78843,726613,772783,492770,474628,712287,147732,340374,730176,319164,290510,577632,439638,943287,351439,870040,1026115) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 113686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 113686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000562s ]