SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001138s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 261440 LIMIT 1 [ RunTime:0.000303s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 261440 [ RunTime:0.001578s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (529171,381658,895252,37330,38127,920560,567944,411595,323310,451396,669294,852331,770016,349407,36535,697691,758812,1031681,620985,689389,828539,107104,728218,873969,279297,1022220,590053,428107,527782,485400,181876,942590,789939,876930,425019,60743,417730,659140,34268,931351,154991,518243,160540,230808,533132,66230,311890,957633,595808,247189,929756,237650,312203,177177,769645,669087,795055,339771,146946,485220) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004151s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 261440 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000454s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 261440 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000580s ]