SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 591228 LIMIT 1 [ RunTime:0.000353s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 591228 [ RunTime:0.001827s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (576256,911010,212743,1047378,678874,645163,148218,186897,873247,557511,922433,1025350,478552,732969,359025,416445,686753,530281,550209,580719,1034048,225321,485159,363145,589831,632297,195540,32485,194469,850429,31772,662285,311447,34129,523757,941977,605012,522900,414492,316617,456982,120902,762016,63472,654915,564572,83832,582154,951878,491642,577070,916112,585577,30511,299180,828123,487221,139206,525154,791709) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001090s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 591228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 591228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000542s ]