SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 132104 LIMIT 1 [ RunTime:0.000319s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 132104 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (587664,814099,477756,866363,248288,189842,359634,462153,89323,764252,558210,478786,133467,750650,204300,619009,285768,112920,915163,930654,69603,162987,201560,44613,587575,375669,119453,109104,748983,291569,179164,19293,918165,744462,270810,547784,978856,270465,32474,945441,561092,808942,412773,848895,653702,501158,137836,16458,362278,236090,156032,179597,174009,494102,212458,1047700,105170,632317,72920,744980) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 132104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 132104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]