SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 901109 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 901109 [ RunTime:0.002682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (853652,795766,287,409858,873102,1044242,481798,543096,568614,270343,1005745,926132,421073,459477,575490,988205,872309,788087,85315,930147,477848,646632,1034863,845457,74163,339966,217281,297411,431216,405529,265223,80768,899977,785437,766900,293627,741738,244675,662703,305256,448918,458106,387683,458443,905478,301569,286339,960588,751028,143533,918030,95896,771023,828037,554603,849897,772524,114228,758321,625964) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001068s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 901109 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000653s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 901109 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000849s ]