SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001137s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047948 LIMIT 1 [ RunTime:0.000318s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047948 [ RunTime:0.001721s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (672838,401615,143463,494642,671538,660460,535148,385329,1047652,721147,929066,235040,131756,677104,598147,871526,662369,227351,813876,679839,410597,20784,497451,845142,370838,208839,166906,1019292,838284,64180,838488,692233,880193,795666,131159,654396,315364,107702,110790,398512,417845,952445,584107,419791,149253,105158,765778,780716,574097,99583,821948,156729,303228,69979,752706,928198,426915,101209,449811,73680) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047948 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047948 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]