SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001237s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 48720 LIMIT 1 [ RunTime:0.000360s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 48720 [ RunTime:0.001762s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (946396,1017938,275025,119164,111908,546912,523470,672393,296658,918790,1031811,71655,859417,248811,115627,368086,28516,298651,442119,202062,736213,801929,48579,118712,895529,753203,1033569,61029,936495,467796,96439,282068,274619,9141,970813,220686,930445,679065,399171,1034318,924971,571016,411131,125961,352612,223866,758888,1005214,594376,926941,826307,937645,338620,883930,515063,640304,360168,358313,359571,377155) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001059s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 48720 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 48720 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000531s ]