SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001190s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004686 LIMIT 1 [ RunTime:0.000340s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004686 [ RunTime:0.003307s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (541836,1012272,626862,677693,816683,850138,800817,144165,364500,829011,549402,762551,492752,86412,153714,464345,906019,199815,96790,383890,307166,648066,202517,125127,378516,767407,332124,654807,913680,239322,288849,772648,971700,554783,309230,634205,642016,834722,874424,1042462,747453,717419,744657,851385,713435,46114,251407,898291,746589,433437,237815,174622,995459,474321,52388,847432,118013,560436,879755,304629) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001020s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000508s ]