SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418975 LIMIT 1 [ RunTime:0.000416s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418975 [ RunTime:0.001857s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (661191,832217,961692,553317,857585,568285,553958,329445,596543,396595,586269,1041950,191556,807568,204801,810749,401103,614708,832584,765794,880332,469409,515063,1026373,96463,665230,448687,555958,589912,117074,387716,121563,682622,691045,290491,903141,975764,216367,769,349061,259417,152967,127317,130166,638428,352192,798588,816882,924440,518887,76467,507484,547018,131855,457902,203168,627406,484340,1011862,825506) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001425s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418975 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000533s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418975 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]