SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001980s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807211 LIMIT 1 [ RunTime:0.005864s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807211 [ RunTime:0.004393s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424760,526053,356942,931835,576055,21502,474266,935269,161537,352761,430129,556109,417568,470609,40231,400842,980679,69700,621080,354919,463929,790642,53954,926572,100649,992502,854134,596878,452718,13925,927038,526067,1045714,981743,716712,611205,1010169,585746,783106,579567,953093,520001,572423,332565,793947,1032202,631020,798168,994901,884178,285569,179931,916019,229645,121333,104138,990369,603329,650333,62261) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001662s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003031s ]